microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 11

In Excel which of the following is not a worksheet design criterion

a) Auditability

b) Efficiency

c) Clarity Correct Answer:

d) Description

Question : 12

In Excel you can edit a cell by

a) Selecting Edit>Edit Cell from the menu

b) Clicking the formula button

c) Double clicking the cell to edit it in-place

d) None of above

Question : 13

In Excel when you use the fill effects in the format data series dialog box, you cannot

a) Select a fore ground color

b) Select a pattern

c) Select a background color

d) Rotate text on the chart

Question : 14

In Excel when you group worksheets

a) You can enter common data, formats, and formulas on multiple worksheets at one time

b) You can print more than one worksheet at a time

c) You can enter variable data on multiple worksheets at one time

d) (B) and (C)

Question : 15

In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?

a) Click page setup on the file menu, click the page tab, click the options button, then enter your choices.

b) Click page setup on the finle menu, click the sheet tab, and make a selection under the print heading.

c) Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles

d) All of above